package com.tjmc.tiomscore.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TranPtnHwPrtExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TranPtnHwPrtExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andRmuidIsNull() {
            addCriterion("rmuid is null");
            return (Criteria) this;
        }

        public Criteria andRmuidIsNotNull() {
            addCriterion("rmuid is not null");
            return (Criteria) this;
        }

        public Criteria andRmuidEqualTo(String value) {
            addCriterion("rmuid =", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotEqualTo(String value) {
            addCriterion("rmuid <>", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidGreaterThan(String value) {
            addCriterion("rmuid >", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidGreaterThanOrEqualTo(String value) {
            addCriterion("rmuid >=", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidLessThan(String value) {
            addCriterion("rmuid <", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidLessThanOrEqualTo(String value) {
            addCriterion("rmuid <=", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidLike(String value) {
            addCriterion("rmuid like", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotLike(String value) {
            addCriterion("rmuid not like", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidIn(List<String> values) {
            addCriterion("rmuid in", values, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotIn(List<String> values) {
            addCriterion("rmuid not in", values, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidBetween(String value1, String value2) {
            addCriterion("rmuid between", value1, value2, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotBetween(String value1, String value2) {
            addCriterion("rmuid not between", value1, value2, "rmuid");
            return (Criteria) this;
        }

        public Criteria andNermuidIsNull() {
            addCriterion("nermuid is null");
            return (Criteria) this;
        }

        public Criteria andNermuidIsNotNull() {
            addCriterion("nermuid is not null");
            return (Criteria) this;
        }

        public Criteria andNermuidEqualTo(String value) {
            addCriterion("nermuid =", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidNotEqualTo(String value) {
            addCriterion("nermuid <>", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidGreaterThan(String value) {
            addCriterion("nermuid >", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidGreaterThanOrEqualTo(String value) {
            addCriterion("nermuid >=", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidLessThan(String value) {
            addCriterion("nermuid <", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidLessThanOrEqualTo(String value) {
            addCriterion("nermuid <=", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidLike(String value) {
            addCriterion("nermuid like", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidNotLike(String value) {
            addCriterion("nermuid not like", value, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidIn(List<String> values) {
            addCriterion("nermuid in", values, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidNotIn(List<String> values) {
            addCriterion("nermuid not in", values, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidBetween(String value1, String value2) {
            addCriterion("nermuid between", value1, value2, "nermuid");
            return (Criteria) this;
        }

        public Criteria andNermuidNotBetween(String value1, String value2) {
            addCriterion("nermuid not between", value1, value2, "nermuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidIsNull() {
            addCriterion("cardrmuid is null");
            return (Criteria) this;
        }

        public Criteria andCardrmuidIsNotNull() {
            addCriterion("cardrmuid is not null");
            return (Criteria) this;
        }

        public Criteria andCardrmuidEqualTo(String value) {
            addCriterion("cardrmuid =", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidNotEqualTo(String value) {
            addCriterion("cardrmuid <>", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidGreaterThan(String value) {
            addCriterion("cardrmuid >", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidGreaterThanOrEqualTo(String value) {
            addCriterion("cardrmuid >=", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidLessThan(String value) {
            addCriterion("cardrmuid <", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidLessThanOrEqualTo(String value) {
            addCriterion("cardrmuid <=", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidLike(String value) {
            addCriterion("cardrmuid like", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidNotLike(String value) {
            addCriterion("cardrmuid not like", value, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidIn(List<String> values) {
            addCriterion("cardrmuid in", values, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidNotIn(List<String> values) {
            addCriterion("cardrmuid not in", values, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidBetween(String value1, String value2) {
            addCriterion("cardrmuid between", value1, value2, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andCardrmuidNotBetween(String value1, String value2) {
            addCriterion("cardrmuid not between", value1, value2, "cardrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidIsNull() {
            addCriterion("holderrmuid is null");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidIsNotNull() {
            addCriterion("holderrmuid is not null");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidEqualTo(String value) {
            addCriterion("holderrmuid =", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidNotEqualTo(String value) {
            addCriterion("holderrmuid <>", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidGreaterThan(String value) {
            addCriterion("holderrmuid >", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidGreaterThanOrEqualTo(String value) {
            addCriterion("holderrmuid >=", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidLessThan(String value) {
            addCriterion("holderrmuid <", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidLessThanOrEqualTo(String value) {
            addCriterion("holderrmuid <=", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidLike(String value) {
            addCriterion("holderrmuid like", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidNotLike(String value) {
            addCriterion("holderrmuid not like", value, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidIn(List<String> values) {
            addCriterion("holderrmuid in", values, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidNotIn(List<String> values) {
            addCriterion("holderrmuid not in", values, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidBetween(String value1, String value2) {
            addCriterion("holderrmuid between", value1, value2, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andHolderrmuidNotBetween(String value1, String value2) {
            addCriterion("holderrmuid not between", value1, value2, "holderrmuid");
            return (Criteria) this;
        }

        public Criteria andPortnoIsNull() {
            addCriterion("portno is null");
            return (Criteria) this;
        }

        public Criteria andPortnoIsNotNull() {
            addCriterion("portno is not null");
            return (Criteria) this;
        }

        public Criteria andPortnoEqualTo(String value) {
            addCriterion("portno =", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoNotEqualTo(String value) {
            addCriterion("portno <>", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoGreaterThan(String value) {
            addCriterion("portno >", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoGreaterThanOrEqualTo(String value) {
            addCriterion("portno >=", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoLessThan(String value) {
            addCriterion("portno <", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoLessThanOrEqualTo(String value) {
            addCriterion("portno <=", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoLike(String value) {
            addCriterion("portno like", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoNotLike(String value) {
            addCriterion("portno not like", value, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoIn(List<String> values) {
            addCriterion("portno in", values, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoNotIn(List<String> values) {
            addCriterion("portno not in", values, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoBetween(String value1, String value2) {
            addCriterion("portno between", value1, value2, "portno");
            return (Criteria) this;
        }

        public Criteria andPortnoNotBetween(String value1, String value2) {
            addCriterion("portno not between", value1, value2, "portno");
            return (Criteria) this;
        }

        public Criteria andNativenameIsNull() {
            addCriterion("nativename is null");
            return (Criteria) this;
        }

        public Criteria andNativenameIsNotNull() {
            addCriterion("nativename is not null");
            return (Criteria) this;
        }

        public Criteria andNativenameEqualTo(String value) {
            addCriterion("nativename =", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotEqualTo(String value) {
            addCriterion("nativename <>", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameGreaterThan(String value) {
            addCriterion("nativename >", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameGreaterThanOrEqualTo(String value) {
            addCriterion("nativename >=", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameLessThan(String value) {
            addCriterion("nativename <", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameLessThanOrEqualTo(String value) {
            addCriterion("nativename <=", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameLike(String value) {
            addCriterion("nativename like", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotLike(String value) {
            addCriterion("nativename not like", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameIn(List<String> values) {
            addCriterion("nativename in", values, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotIn(List<String> values) {
            addCriterion("nativename not in", values, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameBetween(String value1, String value2) {
            addCriterion("nativename between", value1, value2, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotBetween(String value1, String value2) {
            addCriterion("nativename not between", value1, value2, "nativename");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalIsNull() {
            addCriterion("physicalorlogical is null");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalIsNotNull() {
            addCriterion("physicalorlogical is not null");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalEqualTo(String value) {
            addCriterion("physicalorlogical =", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalNotEqualTo(String value) {
            addCriterion("physicalorlogical <>", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalGreaterThan(String value) {
            addCriterion("physicalorlogical >", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalGreaterThanOrEqualTo(String value) {
            addCriterion("physicalorlogical >=", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalLessThan(String value) {
            addCriterion("physicalorlogical <", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalLessThanOrEqualTo(String value) {
            addCriterion("physicalorlogical <=", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalLike(String value) {
            addCriterion("physicalorlogical like", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalNotLike(String value) {
            addCriterion("physicalorlogical not like", value, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalIn(List<String> values) {
            addCriterion("physicalorlogical in", values, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalNotIn(List<String> values) {
            addCriterion("physicalorlogical not in", values, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalBetween(String value1, String value2) {
            addCriterion("physicalorlogical between", value1, value2, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPhysicalorlogicalNotBetween(String value1, String value2) {
            addCriterion("physicalorlogical not between", value1, value2, "physicalorlogical");
            return (Criteria) this;
        }

        public Criteria andPorttypeIsNull() {
            addCriterion("porttype is null");
            return (Criteria) this;
        }

        public Criteria andPorttypeIsNotNull() {
            addCriterion("porttype is not null");
            return (Criteria) this;
        }

        public Criteria andPorttypeEqualTo(String value) {
            addCriterion("porttype =", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeNotEqualTo(String value) {
            addCriterion("porttype <>", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeGreaterThan(String value) {
            addCriterion("porttype >", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeGreaterThanOrEqualTo(String value) {
            addCriterion("porttype >=", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeLessThan(String value) {
            addCriterion("porttype <", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeLessThanOrEqualTo(String value) {
            addCriterion("porttype <=", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeLike(String value) {
            addCriterion("porttype like", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeNotLike(String value) {
            addCriterion("porttype not like", value, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeIn(List<String> values) {
            addCriterion("porttype in", values, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeNotIn(List<String> values) {
            addCriterion("porttype not in", values, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeBetween(String value1, String value2) {
            addCriterion("porttype between", value1, value2, "porttype");
            return (Criteria) this;
        }

        public Criteria andPorttypeNotBetween(String value1, String value2) {
            addCriterion("porttype not between", value1, value2, "porttype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeIsNull() {
            addCriterion("portsubtype is null");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeIsNotNull() {
            addCriterion("portsubtype is not null");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeEqualTo(String value) {
            addCriterion("portsubtype =", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeNotEqualTo(String value) {
            addCriterion("portsubtype <>", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeGreaterThan(String value) {
            addCriterion("portsubtype >", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeGreaterThanOrEqualTo(String value) {
            addCriterion("portsubtype >=", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeLessThan(String value) {
            addCriterion("portsubtype <", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeLessThanOrEqualTo(String value) {
            addCriterion("portsubtype <=", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeLike(String value) {
            addCriterion("portsubtype like", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeNotLike(String value) {
            addCriterion("portsubtype not like", value, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeIn(List<String> values) {
            addCriterion("portsubtype in", values, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeNotIn(List<String> values) {
            addCriterion("portsubtype not in", values, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeBetween(String value1, String value2) {
            addCriterion("portsubtype between", value1, value2, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andPortsubtypeNotBetween(String value1, String value2) {
            addCriterion("portsubtype not between", value1, value2, "portsubtype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeIsNull() {
            addCriterion("signaltype is null");
            return (Criteria) this;
        }

        public Criteria andSignaltypeIsNotNull() {
            addCriterion("signaltype is not null");
            return (Criteria) this;
        }

        public Criteria andSignaltypeEqualTo(String value) {
            addCriterion("signaltype =", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeNotEqualTo(String value) {
            addCriterion("signaltype <>", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeGreaterThan(String value) {
            addCriterion("signaltype >", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeGreaterThanOrEqualTo(String value) {
            addCriterion("signaltype >=", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeLessThan(String value) {
            addCriterion("signaltype <", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeLessThanOrEqualTo(String value) {
            addCriterion("signaltype <=", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeLike(String value) {
            addCriterion("signaltype like", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeNotLike(String value) {
            addCriterion("signaltype not like", value, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeIn(List<String> values) {
            addCriterion("signaltype in", values, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeNotIn(List<String> values) {
            addCriterion("signaltype not in", values, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeBetween(String value1, String value2) {
            addCriterion("signaltype between", value1, value2, "signaltype");
            return (Criteria) this;
        }

        public Criteria andSignaltypeNotBetween(String value1, String value2) {
            addCriterion("signaltype not between", value1, value2, "signaltype");
            return (Criteria) this;
        }

        public Criteria andPortrateIsNull() {
            addCriterion("portrate is null");
            return (Criteria) this;
        }

        public Criteria andPortrateIsNotNull() {
            addCriterion("portrate is not null");
            return (Criteria) this;
        }

        public Criteria andPortrateEqualTo(String value) {
            addCriterion("portrate =", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateNotEqualTo(String value) {
            addCriterion("portrate <>", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateGreaterThan(String value) {
            addCriterion("portrate >", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateGreaterThanOrEqualTo(String value) {
            addCriterion("portrate >=", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateLessThan(String value) {
            addCriterion("portrate <", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateLessThanOrEqualTo(String value) {
            addCriterion("portrate <=", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateLike(String value) {
            addCriterion("portrate like", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateNotLike(String value) {
            addCriterion("portrate not like", value, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateIn(List<String> values) {
            addCriterion("portrate in", values, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateNotIn(List<String> values) {
            addCriterion("portrate not in", values, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateBetween(String value1, String value2) {
            addCriterion("portrate between", value1, value2, "portrate");
            return (Criteria) this;
        }

        public Criteria andPortrateNotBetween(String value1, String value2) {
            addCriterion("portrate not between", value1, value2, "portrate");
            return (Criteria) this;
        }

        public Criteria andDirectionIsNull() {
            addCriterion("direction is null");
            return (Criteria) this;
        }

        public Criteria andDirectionIsNotNull() {
            addCriterion("direction is not null");
            return (Criteria) this;
        }

        public Criteria andDirectionEqualTo(String value) {
            addCriterion("direction =", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionNotEqualTo(String value) {
            addCriterion("direction <>", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionGreaterThan(String value) {
            addCriterion("direction >", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionGreaterThanOrEqualTo(String value) {
            addCriterion("direction >=", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionLessThan(String value) {
            addCriterion("direction <", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionLessThanOrEqualTo(String value) {
            addCriterion("direction <=", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionLike(String value) {
            addCriterion("direction like", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionNotLike(String value) {
            addCriterion("direction not like", value, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionIn(List<String> values) {
            addCriterion("direction in", values, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionNotIn(List<String> values) {
            addCriterion("direction not in", values, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionBetween(String value1, String value2) {
            addCriterion("direction between", value1, value2, "direction");
            return (Criteria) this;
        }

        public Criteria andDirectionNotBetween(String value1, String value2) {
            addCriterion("direction not between", value1, value2, "direction");
            return (Criteria) this;
        }

        public Criteria andRoleIsNull() {
            addCriterion("role is null");
            return (Criteria) this;
        }

        public Criteria andRoleIsNotNull() {
            addCriterion("role is not null");
            return (Criteria) this;
        }

        public Criteria andRoleEqualTo(String value) {
            addCriterion("role =", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleNotEqualTo(String value) {
            addCriterion("role <>", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleGreaterThan(String value) {
            addCriterion("role >", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleGreaterThanOrEqualTo(String value) {
            addCriterion("role >=", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleLessThan(String value) {
            addCriterion("role <", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleLessThanOrEqualTo(String value) {
            addCriterion("role <=", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleLike(String value) {
            addCriterion("role like", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleNotLike(String value) {
            addCriterion("role not like", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleIn(List<String> values) {
            addCriterion("role in", values, "role");
            return (Criteria) this;
        }

        public Criteria andRoleNotIn(List<String> values) {
            addCriterion("role not in", values, "role");
            return (Criteria) this;
        }

        public Criteria andRoleBetween(String value1, String value2) {
            addCriterion("role between", value1, value2, "role");
            return (Criteria) this;
        }

        public Criteria andRoleNotBetween(String value1, String value2) {
            addCriterion("role not between", value1, value2, "role");
            return (Criteria) this;
        }

        public Criteria andIpaddressIsNull() {
            addCriterion("ipaddress is null");
            return (Criteria) this;
        }

        public Criteria andIpaddressIsNotNull() {
            addCriterion("ipaddress is not null");
            return (Criteria) this;
        }

        public Criteria andIpaddressEqualTo(String value) {
            addCriterion("ipaddress =", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotEqualTo(String value) {
            addCriterion("ipaddress <>", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressGreaterThan(String value) {
            addCriterion("ipaddress >", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressGreaterThanOrEqualTo(String value) {
            addCriterion("ipaddress >=", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressLessThan(String value) {
            addCriterion("ipaddress <", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressLessThanOrEqualTo(String value) {
            addCriterion("ipaddress <=", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressLike(String value) {
            addCriterion("ipaddress like", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotLike(String value) {
            addCriterion("ipaddress not like", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressIn(List<String> values) {
            addCriterion("ipaddress in", values, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotIn(List<String> values) {
            addCriterion("ipaddress not in", values, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressBetween(String value1, String value2) {
            addCriterion("ipaddress between", value1, value2, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotBetween(String value1, String value2) {
            addCriterion("ipaddress not between", value1, value2, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpmaskIsNull() {
            addCriterion("ipmask is null");
            return (Criteria) this;
        }

        public Criteria andIpmaskIsNotNull() {
            addCriterion("ipmask is not null");
            return (Criteria) this;
        }

        public Criteria andIpmaskEqualTo(String value) {
            addCriterion("ipmask =", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskNotEqualTo(String value) {
            addCriterion("ipmask <>", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskGreaterThan(String value) {
            addCriterion("ipmask >", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskGreaterThanOrEqualTo(String value) {
            addCriterion("ipmask >=", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskLessThan(String value) {
            addCriterion("ipmask <", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskLessThanOrEqualTo(String value) {
            addCriterion("ipmask <=", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskLike(String value) {
            addCriterion("ipmask like", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskNotLike(String value) {
            addCriterion("ipmask not like", value, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskIn(List<String> values) {
            addCriterion("ipmask in", values, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskNotIn(List<String> values) {
            addCriterion("ipmask not in", values, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskBetween(String value1, String value2) {
            addCriterion("ipmask between", value1, value2, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIpmaskNotBetween(String value1, String value2) {
            addCriterion("ipmask not between", value1, value2, "ipmask");
            return (Criteria) this;
        }

        public Criteria andIsoverlayIsNull() {
            addCriterion("isoverlay is null");
            return (Criteria) this;
        }

        public Criteria andIsoverlayIsNotNull() {
            addCriterion("isoverlay is not null");
            return (Criteria) this;
        }

        public Criteria andIsoverlayEqualTo(String value) {
            addCriterion("isoverlay =", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayNotEqualTo(String value) {
            addCriterion("isoverlay <>", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayGreaterThan(String value) {
            addCriterion("isoverlay >", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayGreaterThanOrEqualTo(String value) {
            addCriterion("isoverlay >=", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayLessThan(String value) {
            addCriterion("isoverlay <", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayLessThanOrEqualTo(String value) {
            addCriterion("isoverlay <=", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayLike(String value) {
            addCriterion("isoverlay like", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayNotLike(String value) {
            addCriterion("isoverlay not like", value, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayIn(List<String> values) {
            addCriterion("isoverlay in", values, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayNotIn(List<String> values) {
            addCriterion("isoverlay not in", values, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayBetween(String value1, String value2) {
            addCriterion("isoverlay between", value1, value2, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andIsoverlayNotBetween(String value1, String value2) {
            addCriterion("isoverlay not between", value1, value2, "isoverlay");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("updateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("updateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("updateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("updateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("updateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("updateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("updateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("updateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("updateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("updateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("updateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}